Is it possible to search for sub-strings... - Mailing list pgsql-general

Ok,   I have a question...   lets say I have a key fields like this...

JYR-34a
JYR-34b
JYR-34c
JJG-67
jUY-89

I want to do a query on a substring,   such that I can get all three
of the JYR's to come up,   regardless if it has an "a",  "b",   or "c"
after it.    Is that possible in SQL?    If so,   what would the query
look like?

John